package uy.edu.um.ltic.server.persistence;

import uy.edu.um.ltic.exception.DataBaseException;
import uy.edu.um.ltic.server.business.Employee;

import java.sql.*;
import java.util.ArrayList;

public interface EmployeeDAOMgt {

	void addEmployee(Employee oEmployee) throws DataBaseException;
	void deleteEmployee(int nEmployee) throws DataBaseException;
	void editEmployee(Employee oEmployee) throws DataBaseException;
	ArrayList<Employee> getEmployees(Employee oEmployee) throws DataBaseException;
	Employee getEmployeeLogIn(String username) throws DataBaseException;
	void createTableEmployees() throws DataBaseException;
	Connection openConnection() throws DataBaseException;
	void dropTable() throws DataBaseException; //BORRAR METODO DESPUES!!!
	void setStatus(int nEmployee, String status) throws DataBaseException;
	ArrayList<Employee> getAllEmployees() throws DataBaseException;
	Employee getEmployeeNEmp(int nEmployee) throws DataBaseException;
	
}
